FaTermAssociationTrackProgramVersion 
Logical Entity Name  FaTermAssociationTrackProgramVersion 
Default Table Name  FaTermAssociationTrackProgramVersion 
Physical Only  NO 
Definition 
 
Note 
 

FaTermAssociationTrackProgramVersion Columns 
ColumnName  Domain  Datatype  NULL  Definition 
FaTermAssociationTrackProgramVersionId(PK)    char(10)  NO 
 
SyCampusGrpID(FK)    int  NO 
 
FaTermAssociationTrackId(FK)    char(10)  NO 
 
AdProgramVersionId(FK)    int  NO 
 
Code    char(10)  NO 
 
Descrip    char(10)  NO 
 
IsActive    char(10)  NO 
 
FaAcademicCalendar    char(10)  YES 
 
AcademicYearType    char(10)  YES 
 
UsesSummer    char(10)  YES 
 
SummerTermHeaderOrTrailer    char(10)  NO 
 
Userid    char(10)  NO 
 
DateAdded    char(10)  NO 
 
DateLstMod    char(10)  NO 
 
ts    char(10)  NO 
 

FaTermAssociationTrackProgramVersion Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_FaTermAssociationTrackProgramVersion_FaTermAssociationTrackProgramVersionId  PrimaryKey  FaTermAssociationTrackProgramVersionId 

FaTermAssociationTrackProgramVersion Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdProgramVersion  Non-Identifying  One To Zero or More  FK_FaTermAssociationTrackProgramVersion_AdProgramVersionId_AdProgramVersion_AdProgramVersionId      AdProgramVersionId  NO  YES 
FaTermAssociationTrack  Non-Identifying  One To Zero or More  FK_FaTermAssociationTrackProgramVersion_FaTermAssociationTrackId_FaTermAssociationTrack_FaTermAssociationTrackId      FaTermAssociationTrackId  NO  YES 
SyCampusGrp  Non-Identifying  One To Zero or More  FK_FaTermAssociationTrackProgramVersion_SyCampusGrpID_SyCampusGrp_SyCampusGrpID      SyCampusGrpID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

FaTermAssociationTrackProgramVersion Check Constraints 
Check Constraint Name  CheckConstraint